Labor Costs Inquiry/Upd by Order# - AP 20

This program allows you to view, correct, and balance labor costs, by comparing the labor costs on an order to an amount billed by the installer or contracting company.

  1. You may use this program to inquire on labor costs, or you can use it to reconcile to a suppliers' labor invoice.
  2. Enter the fields as follows:

    • Enter the order number of the order that contains the labor cost you want to reconcile.
    • Enter the supplier or vendor number that has invoiced you for the labor charges associated with the order. You may enter a ? to search for suppliers or vendors. These fields can be left blank. If a supplier or vendor is entered, the program finds all Installation Teams that are cross referenced to the supplier or vendor. Then, when the order is retrieved, the program looks for the labor lines that include the cross-referenced Installation Teams.
    • Enter the Labor Invoice Amount. This amount is then compared to the labor on the order. Only labor lines with Installation Teams that are cross-referenced to the supplier or vendor are considered. A single order may contain different labor lines supplied by different Installation Teams, which need to be reconciled separately.
      • The labor invoice amount should be keyed with an assumed two decimal places.
    • Enter a password if needed. (This password is set up under keyword APENTR).

  3. This screen displays all labor lines on the order. However, the total cost only includes highlighted lines, which are the lines for installation teams that cross-reference to the supplier or vendor keyed on the previous screen. The screen includes the following information.

    • The installation company on the order displays in the upper left corner of the screen. In the upper right corner, the Installation Team name is displayed, unless the supplier or vendor cross references to multiple installation teams. In that case, the name of the supplier or vendor is shown, and *** is displayed meaning more than one Installation Team.
    • Each labor line is shown, including quantity, unit cost, extended cost, and line status code.
    • You may enter an X in the option (Opt) field to drill down into the line item details, and to make changes if authorized.
    • The variance shown (in this example it is $10.96) is the difference between the Accounts Payable amount (keyed on the first screen) and the total of the highlighted lines. Essentially it is the difference in what you charged your customer for the installation and what the installer charged you.

  4. Enter option X to display and/or update any labor line on the screen.

  5. The labor costs detail line screen enables you to change the unit cost and/or rebate (if you are authorized to change costs). You can also change or assign an installation team code. Changes made using this screen update the order. The order notepad is also updated to show who made what changes. In the example above, the unit cost is changed from 3.75 per SF to 3.97 per SF. When you press Enter, the files are updated, and you are returned to the following screen, showing the affect of the change.

  6. The Labor Cost Inquiry screen now shows the updated costs. Notice that the variance has been reduced from $10.96 to $.04.
  7. Press F21 to display the order where you can update and add lines if needed. For example, you may need to add labor lines that were left off the order, but are now included on the invoice from the supplier/vendor. To update the order, press F6 and then enter the line number.
  8. When you are finished looking at or updating the order, you are returned to the labor costs inquiry.